How to: Unprotect a worksheet.
Solution:
Select the worksheet and select 'Protection' from the 'Tools' menu. Select 'Unprotect Sheet...'.
To unprotect a worksheet:
1) Select the worksheet to unprotect.
2) Select the 'Tools' menu and select 'Protection'. (A submenu appears.)
3) Select 'Unprotect Sheet...' from the submenu.
4) If a password is defined, do the following in the displayed 'Unprotect Sheet' dialog box:
a) Type the defined password in the 'Password' box.
b) Click 'OK'. (The sheet is now unprotected.)